<%
    bean.DataBaseConnection conn = new bean.DataBaseConnection();
%>

<jsp:useBean id="wisata" scope="session" class="bean.Wisata"/>

<%@ page import="java.io.*" %>
<%@ page import="com.oreilly.servlet.MultipartRequest" %>

<%
    /*
     * method dibawah digunakan untuk mengambil parameter untuk mengambil judul,
     * pengarang, penerbit, cover dan pdf yang telah diinputkan dan
     * memasukkannya ke dalam bean.
     */
    String contentType = request.getContentType();
    if ((contentType != null) && (contentType.indexOf("multipart/form-data") >= 0)) {
        MultipartRequest mr = new MultipartRequest(request, request.getRealPath("./CoverGambar"), 1024 * 1024 * 1024);
        wisata.setIdPaket(mr.getParameter("idpaket"));
        wisata.setNamaPaket(mr.getParameter("namaPaket"));
        wisata.setNamaTourGuide(mr.getParameter("namatourguide"));
        wisata.setKuota(Integer.parseInt(mr.getParameter("kuota")));
        wisata.setJamBerangkat(mr.getParameter("jamberangkat"));
        wisata.setRute(mr.getParameter("rute"));
        wisata.setHarga(Integer.parseInt(mr.getParameter("harga")));
        wisata.setCover("./CoverGambar/" + mr.getOriginalFileName("cover"));

    }
%>


<%
    /*
     * method dibawah digunakan untuk mengambil informasi dari dalam java bean
     * dan kemudian informasi tersebut dimasukkan ke dalam database.
     */
    try {

        String query = "INSERT INTO rploinformasi(idpaket, namaPaket, rute, harga, kuota, namatourguide, jamberangkat, cover) VALUES "
                + "('" + wisata.getIdPaket() + "' , '" + wisata.getNamaPaket() + "' , '" + wisata.getRute() + "' , '" + wisata.getHarga()
                + "' , '" + wisata.getKuota() + "', '" + wisata.getNamaTourGuide() + "', '" + wisata.getJamBerangkat() + "', '" + wisata.getCover() + "')";
        java.sql.Statement statement = conn.KoneksiDataBase().createStatement();
        int s = statement.executeUpdate(query);

        System.out.println("Data berhasil dimasukkan \n");

        statement.close();
    } catch (Exception ex) {
        out.println("message1: " + ex.getMessage());
    }
%>



<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Data</title>
    </head>
    <body>
        <style type="text/css">
            #main{
                border: solid;
                color: blue;
                background:white;
                font-weight: bold;
                margin-top: 100px;
                margin-left:120px;
                margin-right:127px;
                margin-bottom:135px;
                padding-right:60px; }

            #menuhor {
                list-style-type: none;
                margin: 0;
                padding: 0;
                float: center;
            }

            #menuhor li {
                margin: 0;
                padding: 0;
                float:left;
                text-align : center;
            }

            #menuhor a {
                display: block;
                width : 247px;
                color: #FFF;
                float : center;
                text-decoration: none;
                line-height:2.5;
                border-right: 3px solid white;
            }

            #menuhor a:hover {
                background: cyan;
            }
            #konten_utama{
                background-color:white;}

            #menuver{
                list-style-type: none;
                margin-left:-40px;
                margin-right:30px;
                padding:0;
                width : 170px;
                background-color:white;
                float:left;
            }
            #menuver li {
                margin:0;
                padding:0;
                float:center;
                text-align : center;
            }
            #menuver a {
                display:block;
                color:#FFF;
                text-decoration:none;
                padding:0.15px;
                line-height: 2.5;
                border-bottom: 3px solid white;
            }
            #menuver a:hover {
                background: cyan;
            }
            #footer{
                font-size: 14px;
                border: solid;
                color: blue;
                clear:both;
                text-align: center;
                background: white;
                margin-top: 350px;
                margin-bottom: 50px;
                height:70px;
                width :950px;
                float:center;

            }
            #konten{
                float:left;

                color: black;
                background: white;
                height:400px;
                width :730px
            }



        </style>
    <body background ="background1.jpg">
        <ul id="main">
            <center><img src="banner.jpg"width="1000" height="300">

                <br>
                <ul id="menuhor" style="position:absolute;right:7px;left:173px;top:345px">
                    <font face="Comic sans MS">
                    <li><a href="HalamanAdmin.jsp"><font color="Blue">Home</a> </li>
                    <li><a href="HalamanPesanan.jsp"><font color="Blue">Pesanan</blink></a> </li>
                    <li><a href="Uploadwisataform.jsp"><font color="Blue">Wisata</blink></a></li>
                    <li><a href="HalamanUtama.jsp"><font color="Blue">Logout</blink></a></li>
                </ul><br><br><hr>

                <ul id="konten_utama">

                    <ul id="menuver">
                        <center> Klik the link below to view packet travel</center>
                        <br>
                        <li><a href="HalamanWisata.jsp"><Marquee><font color="Blue">view packet travel </Marquee></a> </li>
                        <br>
                    </ul>

                    <ul id="konten">
                        <li> Anda telah berhasil upload</li>
                        <li></li>
                    </ul>



                    <br>
                    <br>
                    <br>
                    <ul id="footer">

                        Queries Executed: 0 queries | Page Generation Time: 0.00265 seconds <br>
                        Travel Agent 2.0.4 Beta 10 (Revision 363). Coded by Ardy. Skin coded by Amel and designed by Fave, Hohok
                        All registered trademarks belong to their respective owners. Travel Agent Online and all related content are trademark of Gravity CO. Ltd.
                    </ul></font>
                    </body>
                    </html>

